package logic;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import java.util.ArrayList;

import sql.Itemsql;
import sql.SQLConnection;

public class Items {
	
	
	
	public ArrayList<String>  getitems() throws SQLException 
	{
		Itemsql it = new Itemsql();
		return it.getitemdb();
						
	}
	public ArrayList<String>  getimventory() throws SQLException 
	{
		Itemsql it = new Itemsql();
		return it.getinventory();
						
	}
	public int  putonshelf(ArrayList<String> ar) throws SQLException 
	{
		Itemsql it = new Itemsql();
		return it.putonshelfdb(ar);
						
	}
	public int  deleteitem(int id1) throws SQLException 
	{
		Itemsql it = new Itemsql();
		return it.deleteitemdb(id1);
						
	}
	public int  additem(ArrayList<String> ar) throws SQLException 
	{
		Itemsql it = new Itemsql();
		return it.additemdb(ar);
						
	}
	public int  updateitem(ArrayList<String> ar) throws SQLException 
	{
		Itemsql it = new Itemsql();
		return it.updateitemdb(ar);
						
	}
	public ArrayList<String> getItemNmesList() {
		Itemsql itl = new Itemsql();
		return itl.getItemListDB();
	}
	
	
	
	
	
	
	

}
